Learn the most useful excel functions and formulas from @ . Workbook: Excel shortcuts cheat sheet: ⭐️ Contents ⭐️ ⌨️ (0:00:00) Intro ⌨️ (0:00:44) Cell Referencing ⌨️ (0:05:07) Function Structure ⌨️ (0:09:41) 2 Function Tips ⌨️ (0:10:56) Text Functions ⌨️ (0:12:52) TEXTJOIN Function ⌨️ (0:15:30) Statistical Functions ⌨️ (0:20:01) Mathematical Functions ⌨️ (0:22:38) Rounding Functions ⌨️ (0:24:27) Logical Functions ⌨️ (0:29:14) IFS Function ⌨️ (0:33:25) Counting Functions ⌨️ (0:36:58) Removing Blank Rows With COUNTBLANK ⌨️ (0:40:09) Conditional Functions ⌨️ (0:48:08) VLOOKUP (Exact Match) ⌨️ (0:53:00) VLOOKUP (Approximate Match) ⌨️ (0:55:28) VLOOKUP vs. XLOOKUP ⌨️ (0:58:38) XLOOKUP (Exact Match) ⌨️ (1:02:58) XLOOKUP (Approximate Match) ⌨️ (1:06:38) XLOOKUP (Partial Match) ⌨️ (1:10:15) HLOOKUP ⌨️ (1:12:13) Conclusion ❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: 🎉 Thanks to our Champion and Sponsor supporters: 👾 Drake Milly 👾 Ulises Moralez 👾 Goddard Tan 👾 David MG 👾 Matthew Springman 👾 Claudio 👾 Oscar R. 👾 jedi-or-sith 👾 Nattira Maneerat 👾 Justin Hual -- Learn to code for free and get a developer job: Read hundreds of articles on programming: